[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '28' >
20 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51702_1 | 48F0-4F3E-AE | PO17632172635 | 19 | 291 | 483 | 28 | 6 | 2023-05-18 | 72.00 | 1.80 | 2023-05-06 | 1 | 44.88 | 1 | 72.00 | 1 | SO51702 | 2023-05-13 | 5.76 | 44.88 | 72.00 |
SO51702_2 | 48F0-4F3E-AE | PO17632172635 | 19 | 291 | 573 | 28 | 6 | 2023-05-18 | 1430.44 | 35.76 | 2023-05-06 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO51702 | 2023-05-13 | 114.44 | 1481.94 | 1430.44 |
SO51702_3 | 48F0-4F3E-AE | PO17632172635 | 19 | 291 | 480 | 28 | 6 | 2023-05-18 | 4.12 | 0.10 | 2023-05-06 | 3 | 0.86 | 1 | 4.12 | 3 | SO51702 | 2023-05-13 | 0.33 | 2.57 | 1.37 |
SO57021_1 | D648-4574-9E | PO17632193909 | 19 | 291 | 225 | 28 | 6 | 2023-08-18 | 5.39 | 0.13 | 2023-08-06 | 1 | 6.92 | 1 | 5.39 | 1 | SO57021 | 2023-08-13 | 0.43 | 6.92 | 5.39 |
SO57021_2 | D648-4574-9E | PO17632193909 | 19 | 291 | 463 | 28 | 6 | 2023-08-18 | 29.39 | 0.73 | 2023-08-06 | 2 | 9.16 | 1 | 29.39 | 2 | SO57021 | 2023-08-13 | 2.35 | 18.32 | 14.69 |
SO57021_3 | D648-4574-9E | PO17632193909 | 19 | 291 | 488 | 28 | 6 | 2023-08-18 | 97.18 | 2.43 | 2023-08-06 | 3 | 41.57 | 1 | 97.18 | 3 | SO57021 | 2023-08-13 | 7.77 | 124.72 | 32.39 |
SO57021_4 | D648-4574-9E | PO17632193909 | 19 | 291 | 231 | 28 | 6 | 2023-08-18 | 89.98 | 2.25 | 2023-08-06 | 3 | 38.49 | 1 | 89.98 | 4 | SO57021 | 2023-08-13 | 7.20 | 115.48 | 29.99 |
SO63139_1 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 603 | 28 | 6 | 2023-11-18 | 72.89 | 1.82 | 2023-11-06 | 1 | 53.94 | 1 | 72.89 | 1 | SO63139 | 2023-11-13 | 5.83 | 53.94 | 72.89 |
SO63139_2 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 490 | 28 | 6 | 2023-11-18 | 129.58 | 3.24 | 2023-11-06 | 4 | 41.57 | 1 | 129.58 | 2 | SO63139 | 2023-11-13 | 10.37 | 166.29 | 32.39 |
SO63139_3 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 222 | 28 | 6 | 2023-11-18 | 41.99 | 1.05 | 2023-11-06 | 2 | 13.09 | 1 | 41.99 | 3 | SO63139 | 2023-11-13 | 3.36 | 26.17 | 20.99 |
SO63139_4 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 484 | 28 | 6 | 2023-11-18 | 23.85 | 0.60 | 2023-11-06 | 5 | 2.97 | 1 | 23.85 | 4 | SO63139 | 2023-11-13 | 1.91 | 14.87 | 4.77 |
SO63139_5 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 225 | 28 | 6 | 2023-11-18 | 10.79 | 0.27 | 2023-11-06 | 2 | 6.92 | 1 | 10.79 | 5 | SO63139 | 2023-11-13 | 0.86 | 13.84 | 5.39 |
SO63139_6 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 217 | 28 | 6 | 2023-11-18 | 62.98 | 1.57 | 2023-11-06 | 3 | 13.09 | 1 | 62.98 | 6 | SO63139 | 2023-11-13 | 5.04 | 39.26 | 20.99 |
SO63139_7 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 234 | 28 | 6 | 2023-11-18 | 59.99 | 1.50 | 2023-11-06 | 2 | 38.49 | 1 | 59.99 | 7 | SO63139 | 2023-11-13 | 4.80 | 76.98 | 29.99 |
SO69398_1 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 514 | 28 | 6 | 2024-02-16 | 63.90 | 1.60 | 2024-02-04 | 1 | 47.29 | 1 | 63.90 | 1 | SO69398 | 2024-02-11 | 5.11 | 47.29 | 63.90 |
SO69398_2 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 488 | 28 | 6 | 2024-02-16 | 161.97 | 4.05 | 2024-02-04 | 5 | 41.57 | 1 | 161.97 | 2 | SO69398 | 2024-02-11 | 12.96 | 207.86 | 32.39 |
SO69398_3 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 465 | 28 | 6 | 2024-02-16 | 102.86 | 2.57 | 2024-02-04 | 7 | 9.16 | 1 | 102.86 | 3 | SO69398 | 2024-02-11 | 8.23 | 64.12 | 14.69 |
SO69398_4 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 585 | 28 | 6 | 2024-02-16 | 445.41 | 11.14 | 2024-02-04 | 1 | 461.44 | 1 | 445.41 | 4 | SO69398 | 2024-02-11 | 35.63 | 461.44 | 445.41 |
SO69398_5 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 231 | 28 | 6 | 2024-02-16 | 89.98 | 2.25 | 2024-02-04 | 3 | 38.49 | 1 | 89.98 | 5 | SO69398 | 2024-02-11 | 7.20 | 115.48 | 29.99 |
SO69398_6 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 484 | 28 | 6 | 2024-02-16 | 4.77 | 0.12 | 2024-02-04 | 1 | 2.97 | 1 | 4.77 | 6 | SO69398 | 2024-02-11 | 0.38 | 2.97 | 4.77 |
Generated 2024-05-05 20:05:53.767 UTC